﻿
-- 取得分包及其下属人员信息
create procedure [dbo].[PackageRyInfo_GetTreeAll]
as
select fbid,fbfid,fbmc from Fenb_Info
select Ry_Info.sfzh,fbid,xm+'('+Ry_Info.sfzh+')' xm from Fenbry_Info inner join Ry_Info on(Fenbry_Info.sfzh=Ry_Info.sfzh)